-- Index Deletion
	
IF ( EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblTechnology' AND sysi.name = 'IDX_Technology_ExpertiseLevel' ) )
   DROP INDEX [tblTechnology].[IDX_Technology_ExpertiseLevel]
GO

IF ( EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblGoal' AND sysi.name = 'IDX_Goal_Status' ) )
   DROP INDEX [tblGoal].[IDX_Goal_Status]
GO

IF ( EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblGoalRequiredExpertise' AND sysi.name = 'IDX_GoalRequiredExpertise_Goal' ) )
   DROP INDEX [tblGoalRequiredExpertise].[IDX_GoalRequiredExpertise_Goal]
GO

IF ( EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblGoalRequiredExpertise' AND sysi.name = 'IDX_GoalRequiredExpertise_Technology' ) )
   DROP INDEX [tblGoalRequiredExpertise].[IDX_GoalRequiredExpertise_Technology]
GO

